(대표님) 앱 라우터 api 파트 커밋

1 files changed, 42 insertions, 0 deletions

diff --git a/app/api/oracle/[tableName]/route.ts b/app/api/oracle/[tableName]/route.ts
new file mode 100644
index 00000000..0898421d
--- /dev/null
+++ b/app/api/oracle/[tableName]/route.ts
@@ -0,0 +1,42 @@
+import { NextRequest, NextResponse } from 'next/server';
+import { getTableData } from '@/lib/oracle/db';
+
+interface Params {
+  tableName: string;
+}
+
+interface ApiError {
+  message: string;
+  error?: string;
+}
+
+/**
+ * GET 핸들러 - 테이블 데이터 가져오기
+ */
+export async function GET(
+  request: NextRequest,
+  { params }: { params: Params }
+): Promise<NextResponse<{ data: any[] } | ApiError>> {
+  const { tableName } = params;
+  
+  if (!tableName) {
+    return NextResponse.json(
+      { message: '테이블 이름이 필요합니다.' }, 
+      { status: 400 }
+    );
+  }
+
+  try {
+    const data = await getTableData(tableName);
+    return NextResponse.json({ data }, { status: 200 });
+  } catch (error: any) {
+    console.error('API 에러:', error);
+    return NextResponse.json(
+      { 
+        message: '서버 에러가 발생했습니다.', 
+        error: error.message 
+      }, 
+      { status: 500 }
+    );
+  }
+}
\ No newline at end of file